create procedure [dbo].[BAEImisOrderbadgeUpdate] @ORDER_NUMBER as
float,
    @BADGE_NUMBER AS int,
    @BADGE_TYPE AS varchar(10),
    @FULL_NAME AS varchar(60),
    @TITLE AS varchar(80),
    @COMPANY AS varchar(80),
    @FULL_ADDRESS AS varchar(255),
    @PREFIX AS varchar(10),
    @FIRST_NAME AS varchar(20),
    @MIDDLE_NAME AS varchar(20),
    @LAST_NAME AS varchar(30),
    @SUFFIX AS varchar(10),
    @DESIGNATION AS varchar(20),
    @INFORMAL AS varchar(20),
    @ADDRESS_1 AS varchar(40),
    @ADDRESS_2 AS varchar(40),
    @CITY AS varchar(40),
    @STATE_PROVINCE AS varchar(15),
    @ZIP AS varchar(10),
    @COUNTRY AS varchar(25),
    @BAR_CODE AS varchar(14),
    @DELEGATE AS varchar(10),
    @ST_PRINT_COMPANY AS bit,
    @ST_PRINT_TITLE AS bit
AS
    SELECT * FROM Order_Badge WHERE ORDER_NUMBER = @ORDER_NUMBER AND BADGE_NUMBER = @BADGE_NUMBER
    if(@@ROWCOUNT > 0)
        BEGIN
            UPDATE Order_Badge
            SET
            BADGE_TYPE    =    @BADGE_TYPE,
            FULL_NAME    =    @FULL_NAME,
            TITLE    =    @TITLE,
            COMPANY    =    @COMPANY,
            FULL_ADDRESS    =    @FULL_ADDRESS,
            PREFIX    =    @PREFIX,
            FIRST_NAME    =    @FIRST_NAME,
            MIDDLE_NAME    =    @MIDDLE_NAME,
            LAST_NAME    =    @LAST_NAME,
            SUFFIX    =    @SUFFIX,
            DESIGNATION    =    @DESIGNATION,
            INFORMAL    =    @INFORMAL,
            ADDRESS_1    =    @ADDRESS_1,
            ADDRESS_2    =    @ADDRESS_2,
            CITY    =    @CITY,
            STATE_PROVINCE    =    @STATE_PROVINCE,
            ZIP    =    @ZIP,
            COUNTRY    =    @COUNTRY,
            BAR_CODE    =    @BAR_CODE,
            DELEGATE    =    @DELEGATE,
            ST_PRINT_COMPANY    =    @ST_PRINT_COMPANY,
            ST_PRINT_TITLE    =    @ST_PRINT_TITLE
            WHERE ORDER_NUMBER = @ORDER_NUMBER AND BADGE_NUMBER = @BADGE_NUMBER
        END
    ELSE
        BEGIN
             INSERT INTO Order_Badge
    (
    BADGE_NUMBER,
    BADGE_TYPE,
    FULL_NAME,
    TITLE,
    COMPANY,
    FULL_ADDRESS,
    PREFIX,
    FIRST_NAME,
    MIDDLE_NAME,
    LAST_NAME,
    SUFFIX,
    DESIGNATION,
    INFORMAL,
    ADDRESS_1,
    ADDRESS_2,
    CITY,
    STATE_PROVINCE,
    ZIP,
    COUNTRY,
    BAR_CODE,
    DELEGATE,
    ST_PRINT_COMPANY,
    ST_PRINT_TITLE
    )
    VALUES
    (
    @BADGE_NUMBER,
    @BADGE_TYPE,
    @FULL_NAME,
    @TITLE,
    @COMPANY,
    @FULL_ADDRESS,
    @PREFIX,
    @FIRST_NAME,
    @MIDDLE_NAME,
    @LAST_NAME,
    @SUFFIX,
    @DESIGNATION,
    @INFORMAL,
    @ADDRESS_1,
    @ADDRESS_2,
    @CITY,
    @STATE_PROVINCE,
    @ZIP,
    @COUNTRY,
    @BAR_CODE,
    @DELEGATE,
    @ST_PRINT_COMPANY,
    @ST_PRINT_TITLE
    
);
END

GO